USE [GESTION2]
GO

/****** Object:  StoredProcedure [dbo].[WASP_D0009_CREA_TABLA]    Script Date: 11/22/2011 15:14:01 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WASP_D0009_CREA_TABLA]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[WASP_D0009_CREA_TABLA]
GO

USE [GESTION2]
GO

/****** Object:  StoredProcedure [dbo].[WASP_D0009_CREA_TABLA]    Script Date: 11/22/2011 15:14:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[WASP_D0009_CREA_TABLA] 

AS
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[seg_salud]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[seg_salud]

CREATE TABLE [dbo].[seg_salud] (
	RUT    char  (9),
	DV     char(1),
	NOMBRE char(50),
	AGCOLOC  numeric(2, 0) NULL ,
	NRO_CREDITO	char(9),
	INICIO_COBERTURA decimal(8,0),
	FIN_COBERTURA	decimal(8,0),
	NRO_CUOTAS	char(2),
	TLFONOPEN	char(30),
	DIRTRABAJA	char(40)

)

GO

